package com.itheima.mapper;

import com.itheima.pojo.Emp;
import com.itheima.pojo.EmpQueryParam;
import com.itheima.pojo.OperateLog;
import lombok.extern.slf4j.Slf4j;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;


@Mapper
public interface OperateLogMapper {

    //插入日志数据
    @Insert("insert into operate_log (operate_emp_id, operate_time, class_name, method_name, method_params, return_value, cost_time) " +
            "values (#{operateEmpId}, #{operateTime}, #{className}, #{methodName}, #{methodParams}, #{returnValue}, #{costTime});")
     void insert(OperateLog log);

    //查询日志数据
    //
    @Select("select o.id, o.operate_emp_id, o.operate_time, o.class_name, o.method_name, o.method_params, o.return_value, o.cost_time ,e.name as operateEmpName from operate_log o,emp e where o.operate_emp_id = e.id")
     List<OperateLog> selectAll();


}
